| Original Column Name | Expanded Column Name | Description |
|---|---|---|
| JEEntID | Journal Entry Entity ID | A unique identifier for a particular journal entry within the accounting system. |
| Amt | Amount | The total monetary amount specified in the journal entry. |
| Balance | Balance | The financial balance after the journal entry has been applied. |
| CAID | Cost Allocation ID | An identifier for a cost allocation related to the journal entry. |
| CAEntID | Cost Allocation Entry ID | A unique identifier for an entry detailing cost allocation in a journal entry. |
| CAGrpID | Cost Allocation Group ID | An identifier for a group of related cost allocations, possibly over several journal entries. |
| DeptID | Department ID | The identifier representing the department responsible for or affected by the journal entry. |
| DescX | Description | A detailed explanation or narrative about the journal entry or transaction. |
| DtClr | Date Cleared | The date the transaction was cleared or reconciled in the system. |
| DtPost | Date Posted | The date on which the journal entry was posted to the ledger. |
| DtTrans | Date of Transaction | The date the transaction represented by the journal entry was originally conducted. |
| EmpID | Employee ID | The identification number of an employee involved in the transaction. |
| GLPeriodID | General Ledger Period ID | An identifier for the financial period in which the journal entry was posted. |
| GLTypeID | General Ledger Type ID | An identifier for the type or category of the general ledger entry. |
| JEEntID_Ref | Journal Entry Entity ID Reference | A reference to another journal entry entity ID that is related or linked to this entry. |
| IsCleared | Is Cleared | A flag indicating whether or not the transaction is cleared. |
| IsReverseTrans | Is Reverse Transaction | A flag indicating whether or not the transaction is a reversal of a previous entry. |
| IsVoided | Is Voided | A flag indicating whether or not the journal entry has been voided and should not be considered in financial totals. |
| ItemPOID | Item Purchase Order ID | A unique identifier for the purchase order associated with the item mentioned in the journal entry. |
| PayMethodID | Payment Method ID | The identifier for the method of payment used in the transaction. |
| RecptID | Recipient ID | The identifier for the recipient of funds or goods in the transaction. |
| RecptTypeID | Recipient Type ID | An identifier that categorizes the type of recipient in a transaction (e.g., customer, vendor). |
| RefNo | Reference Number | A unique number used to identify the transaction for documentation or tracking purposes. |
| RefText | Reference Text | Textual description that provides context or additional information for the reference number. |
| SiteID | Site ID | An identifier for the physical location or site involved in the transaction. |
| SourceID | Source ID | The identifier of the source from where the data for the journal entry originates. |
| SourceTypeID | Source Type ID | An identifier that defines the type of source (e.g., automated entry, bank import) that the journal entry data came from. |
| TransTypeID | Transaction Type ID | An identifier denoting the kind of transaction the journal entry represents (e.g., payment, adjustment). |
| ZUChkSum | ZU Checksum | A checksum used for audit trail purposes to verify data integrity. |
| ZUDate | ZU Date | The date recorded in the system's audit logs for tracking changes and data access. |
| ZULogonHisID | ZU Logon History ID | An identifier used to reference a specific instance of logon history in auditing and security monitoring. |